SET identity_insert [dbo].[Incidents]  ON

INSERT 
[dbo].[Incidents] 
([DepartmentType], [Id], [CityId], [CallNumber], [Phone], [UnmaskedPhone], [Title], 
[ReceivedTime], [Address], [ReportingParty], [UnmaskedReportingParty], 
[Description], [UpdateDescription], [Longitude], [Latitude], 
[IsHighPriority], [IncidentCategory], [SearchAreaId]) 
SELECT 3, 380, 28, N'201-4390', N'XXXX-XXXX', N'4157-7005', N'Car reported stolen', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Singapore', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', 103.66646, 1.38637, 0, 1, NULL UNION ALL
SELECT 3, 267, 24, N'201-4390', N'(312) XXX-XXXX', N'(312) 283-0031', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'Street, Cicero, IL 60804', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', -87.77071, 41.86136, 0, 1, NULL UNION ALL
SELECT 3, 268, 24, N'201-4390', N'(312) XXX-XXXX', N'(312) 402-8416', N'Car reported stolen', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'1231 W Adams St, Chicago, IL 60607', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', -87.65818, 41.87855, 0, 1, NULL UNION ALL
SELECT 3, 270, 24, N'201-4390', N'(312) XXX-XXXX', N'(312) 266-6600', N'Man fallen in water', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'170 Thomas St, Oak Park, IL 60302', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', -87.77966, 41.90019, 0, 1, NULL UNION ALL
SELECT 3, 273, 24, N'201-4390', N'(312) XXX-XXXX', N'(312) 202-2376', N'Elderly person fallen in home', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'Street, Chicago, IL 60644', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', -87.74601, 41.87452, 0, 1, NULL UNION ALL
SELECT 3, 274, 24, N'201-4390', N'(312) XXX-XXXX', N'(312) 513-8490', N'Domestic disturbance', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'1125 S 1st Ave, Maywood, IL 60153', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', -87.83388, 41.8779, 0, 1, NULL UNION ALL
SELECT 3, 275, 24, N'201-4390', N'(312) XXX-XXXX', N'(312) 164-3310', N'Public Disturbance', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'Street, Chicago, IL 60651', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', -87.70742, 41.9058, 0, 1, NULL UNION ALL
SELECT 3, 277, 24, N'201-4390', N'(312) XXX-XXXX', N'(312) 342-9632', N'Cat stuck in tree', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'5610 W 22nd St, Cicero, IL 60804', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', -87.7644, 41.8514, 0, 1, NULL UNION ALL
SELECT 3, 279, 24, N'201-4390', N'(312) XXX-XXXX', N'(312) 217-8959', N'Domestic disturbance', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'920 Jackson Blvd, Oak Park, IL 60304', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', -87.79824, 41.87565, 0, 1, NULL UNION ALL
SELECT 3, 280, 24, N'201-4450', N'(312) XXX-XXXX', N'(312) 543-3238', N'Vandalism', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'4545 W Chicago Ave, Chicago, IL 60651', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', -87.73986, 41.89476, 0, 1, NULL UNION ALL
SELECT 3, 281, 24, N'201-4451', N'(312) XXX-XXXX', N'(312) 547-0526', N'Man fallen in water', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'Street, River Grove, IL 60171', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', -87.82757, 41.91194, 0, 1, NULL UNION ALL
SELECT 3, 282, 24, N'201-4452', N'(312) XXX-XXXX', N'(312) 561-7419', N'Speeding', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'S Loomis St, Chicago, IL 60608', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', -87.66111, 41.846, 0, 1, NULL UNION ALL
SELECT 3, 283, 24, N'201-4453', N'(312) XXX-XXXX', N'(312) 593-6332', N'Car break in', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'Street, Berwyn, IL 60402', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', -87.7842, 41.83785, 0, 1, NULL UNION ALL
SELECT 3, 284, 24, N'201-4454', N'(312) XXX-XXXX', N'(312) 969-4305', N'Loud threatening behaviour', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'Street, Forest Park, IL 60130', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', -87.8266, 41.85666, 0, 1, NULL UNION ALL
SELECT 3, 285, 24, N'201-4455', N'(312) XXX-XXXX', N'(312) 119-0718', N'Public Disturbance', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'2074 N Halsted St, Chicago, IL 60614', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', -87.64891, 41.91953, 0, 1, NULL UNION ALL
SELECT 3, 286, 24, N'201-4456', N'(312) XXX-XXXX', N'(312) 59-0157', N'Public Disturbance', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'1657 N Kostner Ave, Chicago, IL 60639', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', -87.73584, 41.91085, 0, 1, NULL UNION ALL
SELECT 3, 287, 24, N'201-4457', N'(312) XXX-XXXX', N'(312) 551-5400', N'Public Disturbance', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'1342 W Hubbard St, Chicago, IL 60642', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', -87.6606, 41.89003, 0, 1, NULL UNION ALL
SELECT 3, 288, 24, N'201-4458', N'(312) XXX-XXXX', N'(312) 496-9965', N'Public Disturbance', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'5014 W Belmont Ave, Chicago, IL 60641', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', -87.75211, 41.93894, 0, 1, NULL UNION ALL
SELECT 3, 289, 24, N'201-4459', N'(312) XXX-XXXX', N'(312) 875-1204', N'Public Disturbance', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'2716 N Marmora Ave, Chicago, IL 60639', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', -87.77375, 41.92979, 0, 1, NULL UNION ALL
SELECT 3, 295, 25, N'201-4390', N'(11) XXX-XXXX', N'(11) 616-4241', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'542 Marthinus Smuts Dr, Johannesburg, 1862, South Africa', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', 27.95422, -26.24757, 0, 1, NULL UNION ALL
SELECT 3, 296, 25, N'201-4390', N'(11) XXX-XXXX', N'(11) 943-9575', N'Car reported stolen', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'Camelia Lane, Bedfordview, 2007, South Africa', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', 28.15167, -26.16822, 0, 1, NULL UNION ALL
SELECT 3, 298, 25, N'201-4390', N'(11) XXX-XXXX', N'(11) 532-8696', N'Man fallen in water', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'Johannesburg, 2091, South Africa', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', 27.98594, -26.16243, 0, 1, NULL UNION ALL
SELECT 3, 301, 25, N'201-4390', N'(11) XXX-XXXX', N'(11) 521-5672', N'Elderly person fallen in home', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'18 Huxton Rd, Johannesburg, 2091, South Africa', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', 28.01868, -26.24384, 0, 1, NULL UNION ALL
SELECT 3, 302, 25, N'201-4390', N'(11) XXX-XXXX', N'(11) 628-9470', N'Domestic disturbance', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'35 Majuba Ave, Johannesburg, 1717, South Africa', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', 27.95382, -26.19852, 0, 1, NULL UNION ALL
SELECT 3, 303, 25, N'201-4390', N'(11) XXX-XXXX', N'(11) 835-5448', N'Public Disturbance', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'61 Sneddon St, Johannesburg, 2192, South Africa', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', 28.09488, -26.15409, 0, 1, NULL UNION ALL
SELECT 3, 305, 25, N'201-4390', N'(11) XXX-XXXX', N'(11) 258-8335', N'Cat stuck in tree', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'33 Hoofd St, Johannesburg, 2001, South Africa', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', 28.03966, -26.18953, 0, 1, NULL UNION ALL
SELECT 3, 307, 25, N'201-4390', N'(11) XXX-XXXX', N'(11) 64-7960', N'Domestic disturbance', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'South Rand Rd, Johannesburg, 2190, South Africa', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', 28.08099, -26.25874, 0, 1, NULL UNION ALL
SELECT 3, 308, 25, N'201-4450', N'(11) XXX-XXXX', N'(11) 13-9234', N'Vandalism', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'103 Charles St, Johannesburg, 2092, South Africa', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', 27.9638, -26.17926, 0, 1, NULL UNION ALL
SELECT 3, 309, 25, N'201-4451', N'(11) XXX-XXXX', N'(11) 991-2618', N'Man fallen in water', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'4th St & 3rd Ave, Johannesburg, 2001, South Africa', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', 28.01219, -26.23049, 0, 1, NULL UNION ALL
SELECT 3, 310, 25, N'201-4452', N'(11) XXX-XXXX', N'(11) 501-7692', N'Speeding', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'14 St Francis Rd, Bedfordview, 2007, South Africa', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', 28.13142, -26.15606, 0, 1, NULL UNION ALL
SELECT 3, 311, 25, N'201-4453', N'(11) XXX-XXXX', N'(11) 726-2366', N'Car break in', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'31 10th Ave, Johannesburg, 2192, South Africa', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', 28.07583, -26.14359, 0, 1, NULL UNION ALL
SELECT 3, 312, 25, N'201-4454', N'(11) XXX-XXXX', N'(11) 631-4008', N'Loud threatening behaviour', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'16 Baldwin Rd, Johannesburg, South Africa', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', 28.04484, -26.22369, 0, 1, NULL UNION ALL
SELECT 3, 313, 25, N'201-4455', N'(11) XXX-XXXX', N'(11) 116-1033', N'Public Disturbance', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'99 Booysens Reserve Rd, Johannesburg, 2001, South Africa', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', 27.99484, -26.23166, 0, 1, NULL UNION ALL
SELECT 3, 314, 25, N'201-4456', N'(11) XXX-XXXX', N'(11) 576-7275', N'Public Disturbance', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'46 8th St, Johannesburg, 2198, South Africa', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', 28.04797, -26.15103, 0, 1, NULL UNION ALL
SELECT 3, 315, 25, N'201-4457', N'(11) XXX-XXXX', N'(11) 530-3672', N'Public Disturbance', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'23 Earp St, Johannesburg, 2001, South Africa', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', 28.02943, -26.21791, 0, 1, NULL UNION ALL
SELECT 3, 316, 25, N'201-4458', N'(11) XXX-XXXX', N'(11) 977-8783', N'Public Disturbance', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'12A Jellicoe Ave, Johannesburg, 2196, South Africa', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', 28.03898, -26.14353, 0, 1, NULL UNION ALL
SELECT 3, 317, 25, N'201-4459', N'(11) XXX-XXXX', N'(11) 697-5004', N'Public Disturbance', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'93 Whitworth Rd, Johannesburg, 2094, South Africa', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', 28.1194, -26.21082, 0, 1, NULL UNION ALL
SELECT 3, 323, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 510-026', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Klüberstraße 8, 60325 Frankfurt', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', 8.66606, 50.11322, 0, 1, NULL UNION ALL
SELECT 3, 324, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 951-475', N'Car reported stolen', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Schnappbornweg 85, 60599 Frankfurt', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', 8.70099, 50.09094, 0, 1, NULL UNION ALL
SELECT 3, 326, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 612-955', N'Man fallen in water', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Königsbrunnenweg, 60598 Frankfurt', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', 8.67556, 50.07612, 0, 1, NULL UNION ALL
SELECT 3, 329, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 346-249', N'Elderly person fallen in home', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Stoltzeschneise, 60599 Frankfurt', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', 8.70521, 50.084, 0, 1, NULL UNION ALL
SELECT 3, 330, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 840-982', N'Domestic disturbance', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'A66, 60488 Frankfurt', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', 8.63163, 50.13464, 0, 1, NULL UNION ALL
SELECT 3, 328, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 125-060', N'Car break in', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Golfstraße, 60528 Frankfurt', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', 8.63006, 50.07539, 0, 6, NULL UNION ALL
SELECT 3, 331, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 593-899', N'Public Disturbance', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Schnappbornweg 100, 60599 Frankfurt', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', 8.70548, 50.0931, 0, 1, NULL UNION ALL
SELECT 3, 333, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 366-524', N'Cat stuck in tree', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Heinrich-Plett-Straße 5, 60433 Frankfurt', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', 8.68337, 50.17001, 0, 1, NULL UNION ALL
SELECT 3, 335, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 973-124', N'Domestic disturbance', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Karpfenweg 6, 60327 Frankfurt', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', 8.66231, 50.10019, 0, 1, NULL UNION ALL
SELECT 3, 336, 26, N'201-4450', N'(69) XXX-XXX', N'(69) 86-630', N'Vandalism', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Georg-Esser-Anlage 18, 60435 Frankfurt', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', 8.68111, 50.15169, 0, 1, NULL UNION ALL
SELECT 3, 337, 26, N'201-4451', N'(69) XXX-XXX', N'(69) 437-200', N'Man fallen in water', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Klepperschneise, 60599 Frankfurt', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', 8.7204, 50.07998, 0, 1, NULL UNION ALL
SELECT 3, 338, 26, N'201-4452', N'(69) XXX-XXX', N'(69) 498-472', N'Speeding', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Street, 60439 Frankfurt', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', 8.63418, 50.14986, 0, 1, NULL UNION ALL
SELECT 3, 339, 26, N'201-4453', N'(69) XXX-XXX', N'(69) 723-560', N'Car break in', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Dreihäusergasse 3, 60433 Frankfurt', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', 8.65637, 50.16172, 0, 1, NULL UNION ALL
SELECT 3, 340, 26, N'201-4454', N'(69) XXX-XXX', N'(69) 472-136', N'Loud threatening behaviour', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Schwarzsteinkautweg, 60598 Frankfurt', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', 8.66826, 50.08572, 0, 1, NULL UNION ALL
SELECT 3, 341, 26, N'201-4455', N'(69) XXX-XXX', N'(69) 671-580', N'Public Disturbance', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Maunzenweiherschneise, 60599 Frankfurt', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', 8.72908, 50.08325, 0, 1, NULL UNION ALL
SELECT 3, 342, 26, N'201-4456', N'(69) XXX-XXX', N'(69) 585-345', N'Public Disturbance', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'B3, 60435 Frankfurt', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', 8.70254, 50.16925, 0, 1, NULL UNION ALL
SELECT 3, 343, 26, N'201-4457', N'(69) XXX-XXX', N'(69) 216-503', N'Public Disturbance', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Rödelheimer Parkweg, 60489 Frankfurt', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', 8.6206, 50.12538, 0, 1, NULL UNION ALL
SELECT 3, 344, 26, N'201-4458', N'(69) XXX-XXX', N'(69) 540-040', N'Public Disturbance', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Miquelallee, 60323 Frankfurt', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', 8.6638, 50.13111, 0, 1, NULL UNION ALL
SELECT 3, 345, 26, N'201-4459', N'(69) XXX-XXX', N'(69) 141-616', N'Public Disturbance', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Schwanheimer Ufer, 60529 Frankfurt', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', 8.62662, 50.08746, 0, 1, NULL UNION ALL
SELECT 3, 351, 27, N'201-4390', N'(202) XXX-XXXX', N'(202) 020-0631', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'419 Dateleaf Ave, Capitol Heights, MD 20743', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', -76.89425, 38.89565, 0, 1, NULL UNION ALL
SELECT 3, 352, 27, N'201-4390', N'(202) XXX-XXXX', N'(202) 394-2297', N'Car reported stolen', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'5036 Sheriff Rd NE, Washington, DC 20019', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', -76.92805, 38.90375, 0, 1, NULL UNION ALL
SELECT 3, 354, 27, N'201-4390', N'(202) XXX-XXXX', N'(202) 434-2131', N'Man fallen in water', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'VA-267 E, Falls Church, VA 22043', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', -77.18777, 38.90097, 0, 1, NULL UNION ALL
SELECT 3, 357, 27, N'201-4390', N'(202) XXX-XXXX', N'(202) 298-7426', N'Elderly person fallen in home', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'Street, Hyattsville, MD 20781', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', -76.93622, 38.92212, 0, 1, NULL UNION ALL
SELECT 3, 358, 27, N'201-4390', N'(202) XXX-XXXX', N'(202) 525-7025', N'Domestic disturbance', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'1295 Aldebaran Dr, McLean, VA 22101', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', -77.15682, 38.9373, 0, 1, NULL UNION ALL
SELECT 3, 359, 27, N'201-4390', N'(202) XXX-XXXX', N'(202) 967-5091', N'Public Disturbance', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'3205 Pennsylvania Ave SE, Washington, DC 20020', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', -76.95976, 38.86899, 0, 1, NULL UNION ALL
SELECT 3, 361, 27, N'201-4390', N'(202) XXX-XXXX', N'(202) 493-9988', N'Cat stuck in tree', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'Washington, DC', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', -76.96146, 38.90416, 0, 1, NULL UNION ALL
SELECT 3, 363, 27, N'201-4390', N'(202) XXX-XXXX', N'(202) 441-1801', N'Domestic disturbance', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'Arlington Memorial Bridge, Washington, DC 20024', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', -77.05506, 38.88668, 0, 1, NULL UNION ALL
SELECT 3, 364, 27, N'201-4450', N'(202) XXX-XXXX', N'(202) 355-7156', N'Vandalism', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'5995 Merritt Pl, Falls Church, VA 22041', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', -77.13271, 38.85835, 0, 1, NULL UNION ALL
SELECT 3, 365, 27, N'201-4451', N'(202) XXX-XXXX', N'(202) 201-3725', N'Man fallen in water', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'Street, Washington, DC 20016', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', -77.06885, 38.9311, 0, 1, NULL UNION ALL
SELECT 3, 366, 27, N'201-4452', N'(202) XXX-XXXX', N'(202) 531-5368', N'Speeding', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'1711 Hobart St NW, Washington, DC 20009', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', -77.04016, 38.92805, 0, 1, NULL UNION ALL
SELECT 3, 367, 27, N'201-4453', N'(202) XXX-XXXX', N'(202) 058-4381', N'Car break in', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'Willow St, Falls Church, VA 22046', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', -77.18378, 38.89537, 0, 1, NULL UNION ALL
SELECT 3, 368, 27, N'201-4454', N'(202) XXX-XXXX', N'(202) 736-2145', N'Loud threatening behaviour', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'Street, Washington, VA 20001', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', -77.04496, 38.85702, 0, 1, NULL UNION ALL
SELECT 3, 369, 27, N'201-4455', N'(202) XXX-XXXX', N'(202) 027-9342', N'Public Disturbance', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'Street, Washington, DC 20019', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', -76.95145, 38.90969, 0, 1, NULL UNION ALL
SELECT 3, 370, 27, N'201-4456', N'(202) XXX-XXXX', N'(202) 916-1529', N'Public Disturbance', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'2257 S Eads St, Arlington, VA 22202', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', -77.05313, 38.85369, 0, 1, NULL UNION ALL
SELECT 3, 371, 27, N'201-4457', N'(202) XXX-XXXX', N'(202) 195-4432', N'Public Disturbance', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'5712 Kansas Ave NW, Washington, DC 20011', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', -77.01327, 38.95894, 0, 1, NULL UNION ALL
SELECT 3, 372, 27, N'201-4458', N'(202) XXX-XXXX', N'(202) 062-7754', N'Public Disturbance', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'270 Peabody St NE, Washington, DC 20011', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', -77.00332, 38.9629, 0, 1, NULL UNION ALL
SELECT 3, 373, 27, N'201-4459', N'(202) XXX-XXXX', N'(202) 651-6895', N'Public Disturbance', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'2470 17th St NW, Washington, DC 20009', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', -77.03897, 38.92262, 0, 1, NULL UNION ALL
SELECT 3, 379, 28, N'201-4390', N'XXXX-XXXX', N'7751-5199', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'81560 Gelang Patah, Johore, Malaysia', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', 103.59453, 1.34679, 0, 1, NULL UNION ALL
SELECT 3, 385, 28, N'201-4390', N'XXXX-XXXX', N'262-2995', N'Elderly person fallen in home', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Jurong West St 81, Singapore, Singapore', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', 103.69323, 1.34503, 0, 1, NULL UNION ALL
SELECT 3, 382, 28, N'201-4390', N'XXXX-XXXX', N'8861-9474', N'Man fallen in water', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Singapore', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', 103.65497, 1.35599, 0, 1, NULL UNION ALL
SELECT 3, 386, 28, N'201-4390', N'XXXX-XXXX', N'6426-4899', N'Domestic disturbance', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Kaki Bukit Rd 3, Singapore, Singapore', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', 103.90341, 1.33747, 0, 1, NULL UNION ALL
SELECT 3, 387, 28, N'201-4390', N'XXXX-XXXX', N'3165-8010', N'Public Disturbance', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'International Rd, Singapore, Singapore', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', 103.71833, 1.33025, 0, 1, NULL UNION ALL
SELECT 3, 389, 28, N'201-4390', N'XXXX-XXXX', N'4389-5791', N'Cat stuck in tree', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'1 Pegu Rd, Singapore 328358, Singapore', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', 103.85148, 1.32301, 0, 1, NULL UNION ALL
SELECT 3, 391, 28, N'201-4390', N'XXXX-XXXX', N'3106-8511', N'Domestic disturbance', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Singapore, Singapore', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', 103.95192, 1.31173, 0, 1, NULL UNION ALL
SELECT 3, 392, 28, N'201-4450', N'XXXX-XXXX', N'2639-5252', N'Vandalism', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Singapore, Singapore', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', 103.95011, 1.40857, 0, 1, NULL UNION ALL
SELECT 3, 393, 28, N'201-4451', N'XXXX-XXXX', N'4700-9070', N'Man fallen in water', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'450G Tampines St 42, Singapore 527450, Singapore', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', 103.95277, 1.35837, 0, 1, NULL UNION ALL
SELECT 3, 394, 28, N'201-4452', N'XXXX-XXXX', N'689-0009', N'Speeding', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Ang Mo Kio Ave 1, Singapore, Singapore', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', 103.8599, 1.35482, 0, 1, NULL UNION ALL
SELECT 3, 395, 28, N'201-4453', N'XXXX-XXXX', N'4133-7308', N'Car break in', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Pengerang, Johore, Malaysia', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', 104.12727, 1.36525, 0, 1, NULL UNION ALL
SELECT 3, 396, 28, N'201-4454', N'XXXX-XXXX', N'9532-7242', N'Loud threatening behaviour', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Tampines Flyover, Singapore, Singapore', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', 103.91803, 1.38355, 0, 1, NULL UNION ALL
SELECT 3, 397, 28, N'201-4455', N'XXXX-XXXX', N'8657-6922', N'Public Disturbance', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Marine Parade Rd, Singapore, Singapore', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', 103.90276, 1.30103, 0, 1, NULL UNION ALL
SELECT 3, 398, 28, N'201-4456', N'XXXX-XXXX', N'3062-6202', N'Public Disturbance', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Singapore, Singapore', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', 103.83623, 1.29969, 0, 1, NULL UNION ALL
SELECT 3, 399, 28, N'201-4457', N'XXXX-XXXX', N'5354-8141', N'Public Disturbance', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Singapore', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', 103.66221, 1.33002, 0, 1, NULL UNION ALL
SELECT 3, 400, 28, N'201-4458', N'XXXX-XXXX', N'6103-6527', N'Public Disturbance', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'81560 Gelang Patah, Johore, Malaysia', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', 103.60399, 1.34973, 0, 1, NULL UNION ALL
SELECT 3, 401, 28, N'201-4459', N'XXXX-XXXX', N'1514-5224', N'Public Disturbance', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'81 Verde Cres, Singapore 688436, Singapore', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', 103.75037, 1.39045, 0, 1, NULL UNION ALL
SELECT 3, 407, 29, N'201-4390', N'(80) XXXX-XXXX', N'(80) 0580-5783', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'Chikka Adugodi, Tavarekere, Bengaluru 560029, India', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', 77.61118, 12.92878, 0, 1, NULL UNION ALL
SELECT 3, 408, 29, N'201-4390', N'(80) XXXX-XXXX', N'(80) 0140-2636', N'Car reported stolen', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'1st Main Road, Kaval Byrasandra, Bengaluru 560032, India', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', 77.60935, 13.02245, 0, 1, NULL UNION ALL
SELECT 3, 410, 29, N'201-4390', N'(80) XXXX-XXXX', N'(80) 0093-8143', N'Man fallen in water', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'Jayamahal Main Road, Vasantha Nagar, Bengaluru 560046, India', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', 77.59464, 12.99591, 0, 1, NULL UNION ALL
SELECT 3, 413, 29, N'201-4390', N'(80) XXXX-XXXX', N'(80) 0772-2645', N'Elderly person fallen in home', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'24/2, Chinnayana Palya, Wilson Garden, Bengaluru 560027, India', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', 77.6019, 12.9472, 0, 1, NULL UNION ALL
SELECT 3, 414, 29, N'201-4390', N'(80) XXXX-XXXX', N'(80) 0505-3515', N'Domestic disturbance', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'SH-85, Railway Colony, Okalipuram, Bengaluru 560009, India', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', 77.5703, 12.98232, 0, 1, NULL UNION ALL
SELECT 3, 415, 29, N'201-4390', N'(80) XXXX-XXXX', N'(80) 0967-5306', N'Public Disturbance', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'K R Road, Kalasipalyam, Bengaluru 560002, India', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', 77.57424, 12.9589, 0, 1, NULL UNION ALL
SELECT 3, 417, 29, N'201-4390', N'(80) XXXX-XXXX', N'(80) 0054-8136', N'Cat stuck in tree', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'Halasuru, Bengaluru 560008, India', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', 77.61864, 12.98669, 0, 1, NULL UNION ALL
SELECT 3, 419, 29, N'201-4390', N'(80) XXXX-XXXX', N'(80) 0664-3762', N'Domestic disturbance', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'999 12th Main Road, Hanumantha Nagar, Bengaluru 560019, India', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', 77.55956, 12.94543, 0, 1, NULL UNION ALL
SELECT 3, 420, 29, N'201-4450', N'(80) XXXX-XXXX', N'(80) 0215-4079', N'Vandalism', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'Asc Centre Area-Agram, Vivek Nagar, Bengaluru 560007, India', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', 77.62188, 12.95752, 0, 1, NULL UNION ALL
SELECT 3, 421, 29, N'201-4451', N'(80) XXXX-XXXX', N'(80) 0395-2077', N'Man fallen in water', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'136 Residency Road, Ashoka Nagar, Bengaluru 560001, India', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', 77.59797, 12.9659, 0, 1, NULL UNION ALL
SELECT 3, 422, 29, N'201-4452', N'(80) XXXX-XXXX', N'(80) 0328-5716', N'Speeding', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'144 1st D Main Road, Domlur, Bengaluru 560071, India', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', 77.63673, 12.95907, 0, 1, NULL UNION ALL
SELECT 3, 423, 29, N'201-4453', N'(80) XXXX-XXXX', N'(80) 0174-5099', N'Car break in', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'36 3rd Cross Road, Marappa Palya, Yeshwanthpur, Bengaluru 560022, India', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', 77.55022, 13.01231, 0, 1, NULL UNION ALL
SELECT 3, 424, 29, N'201-4454', N'(80) XXXX-XXXX', N'(80) 0319-7426', N'Loud threatening behaviour', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'2nd Stage, Rajajinagar, Bengaluru 560010, India', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', 77.55651, 13.01053, 0, 1, NULL UNION ALL
SELECT 3, 425, 29, N'201-4455', N'(80) XXXX-XXXX', N'(80) 0510-3377', N'Public Disturbance', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'8 1st Cross Road, Jogupalya-New Saraswathipuram, Halasuru, Bengaluru 560008, India', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', 77.63181, 12.97246, 0, 1, NULL UNION ALL
SELECT 3, 426, 29, N'201-4456', N'(80) XXXX-XXXX', N'(80) 0596-1693', N'Public Disturbance', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'933/B 21st Main Road, 2nd Phase, J P Nagar, Bengaluru 560078, India', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', 77.58778, 12.90906, 0, 1, NULL UNION ALL
SELECT 3, 427, 29, N'201-4457', N'(80) XXXX-XXXX', N'(80) 0458-0560', N'Public Disturbance', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'Doddanna Nagar, DJ Halli, Bengaluru 560045, India', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', 77.6038, 13.01647, 0, 1, NULL UNION ALL
SELECT 3, 428, 29, N'201-4458', N'(80) XXXX-XXXX', N'(80) 0309-9799', N'Public Disturbance', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'3rd Shop Line Road, Tata Silk Farm, Basavanagudi, Bengaluru 560004, India', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', 77.57443, 12.93508, 0, 1, NULL UNION ALL
SELECT 3, 429, 29, N'201-4459', N'(80) XXXX-XXXX', N'(80) 0854-5408', N'Public Disturbance', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'C-158 No. J4 Road, KPWD Quarters, Jeevan Bheema Nagar, Bengaluru 560075, India', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', 77.65551, 12.96651, 0, 1, NULL UNION ALL
SELECT 3, 441, 30, N'201-4390', N'(911) XXXX-XXXX', N'(911) 9294-8276', N'Elderly person fallen in home', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Via Cisliano 80, 20090 Cusago MI', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', 9.02149, 45.44922, 0, 1, NULL UNION ALL
SELECT 3, 442, 30, N'201-4390', N'(911) XXXX-XXXX', N'(911) 2079-7370', N'Domestic disturbance', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Via Guglielmo Marconi 13, 20090 Segrate MI', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', 9.27723, 45.49602, 0, 1, NULL UNION ALL
SELECT 3, 443, 30, N'201-4390', N'(911) XXXX-XXXX', N'(911) 8681-7281', N'Public Disturbance', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Via Ercole Santi & Highway, 28100 Novara NO', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', 8.67369, 45.46524, 0, 1, NULL UNION ALL
SELECT 3, 447, 30, N'201-4390', N'(911) XXXX-XXXX', N'(911) 6118-2795', N'Domestic disturbance', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Via Remigio Paone, 20153 Milan MI', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', 9.10639, 45.47048, 0, 1, NULL UNION ALL
SELECT 3, 445, 30, N'201-4390', N'(911) XXXX-XXXX', N'(911) 5830-8389', N'Cat stuck in tree', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Strada Cons. Vecchia Paullese, 20060 Mediglia MI', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', 9.37853, 45.42061, 0, 1, NULL UNION ALL
SELECT 3, 448, 30, N'201-4450', N'(911) XXXX-XXXX', N'(911) 1287-0564', N'Vandalism', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Novara, Piem., Italy', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', 8.64761, 45.47215, 0, 1, NULL UNION ALL
SELECT 3, 449, 30, N'201-4451', N'(911) XXXX-XXXX', N'(911) 2988-7327', N'Man fallen in water', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Rivolta d''Adda, Lomb., Italy', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', 9.50891, 45.49197, 0, 1, NULL UNION ALL
SELECT 3, 450, 30, N'201-4452', N'(911) XXXX-XXXX', N'(911) 4880-8778', N'Speeding', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Fornovo San Giovanni, Lomb., Italy', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', 9.71601, 45.49082, 0, 1, NULL UNION ALL
SELECT 3, 451, 30, N'201-4453', N'(911) XXXX-XXXX', N'(911) 2735-2970', N'Car break in', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Via Arno 45, 20090 Trezzano sul Naviglio MI', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', 9.07812, 45.42402, 0, 1, NULL UNION ALL
SELECT 3, 452, 30, N'201-4454', N'(911) XXXX-XXXX', N'(911) 6295-3000', N'Loud threatening behaviour', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Svincolo SS33-Sempione, 20017 Rho MI', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', 9.05977, 45.52653, 0, 1, NULL UNION ALL
SELECT 3, 453, 30, N'201-4455', N'(911) XXXX-XXXX', N'(911) 1888-4912', N'Public Disturbance', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Street, 28060 San Pietro Mosezzo NO', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', 8.53584, 45.48746, 0, 1, NULL UNION ALL
SELECT 3, 454, 30, N'201-4456', N'(911) XXXX-XXXX', N'(911) 9444-9974', N'Public Disturbance', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Strada comunale Trescore, 26017 Torlino Vimercati CR', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', 9.6032, 45.41642, 0, 1, NULL UNION ALL
SELECT 3, 455, 30, N'201-4457', N'(911) XXXX-XXXX', N'(911) 4953-2122', N'Public Disturbance', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Cascina Besozza, 20096 Pioltello MI', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', 9.31871, 45.47487, 0, 1, NULL UNION ALL
SELECT 3, 456, 30, N'201-4458', N'(911) XXXX-XXXX', N'(911) 2815-3633', N'Public Disturbance', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Strada comunale della Baragiola, 20012 Cuggiono MI', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', 8.76819, 45.50125, 0, 1, NULL UNION ALL
SELECT 3, 457, 30, N'201-4459', N'(911) XXXX-XXXX', N'(911) 7889-9842', N'Public Disturbance', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Via Arona 4, 20149 Milan MI', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', 9.16019, 45.48376, 0, 1, NULL UNION ALL
SELECT 3, 435, 30, N'201-4390', N'(911) XXXX-XXXX', N'(911) 4232-0838', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Street, 28065 Cerano NO', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', 8.80071, 45.42936, 0, 1, NULL UNION ALL
SELECT 3, 436, 30, N'201-4390', N'(911) XXXX-XXXX', N'(911) 2946-0635', N'Car reported stolen', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Street, 24058 Romano di Lombardia BG', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', 9.75075, 45.50657, 0, 1, NULL UNION ALL
SELECT 3, 438, 30, N'201-4390', N'(911) XXXX-XXXX', N'(911) 5110-0118', N'Man fallen in water', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Merlino, Lomb., Italy', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', 9.42715, 45.44044, 0, 1, NULL UNION ALL
SELECT 3, 463, 31, N'201-4390', N'(85) XXX-XXXX', N'(85) 777-6958', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Amsterdam-Zuidoost, Amsterdam, North Holland, Netherlands', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', 5.0059, 52.31833, 0, 1, NULL UNION ALL
SELECT 3, 464, 31, N'201-4390', N'(85) XXX-XXXX', N'(85) 754-2911', N'Car reported stolen', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Burgemeester de Vlugtlaan 2, 1063 BR Amsterdam, Netherlands', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', 4.83683, 52.37948, 0, 1, NULL UNION ALL
SELECT 3, 466, 31, N'201-4390', N'(85) XXX-XXXX', N'(85) 578-7629', N'Man fallen in water', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'1187 Amstelveen, Netherlands', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', 4.82128, 52.30484, 0, 1, NULL UNION ALL
SELECT 3, 469, 31, N'201-4390', N'(85) XXX-XXXX', N'(85) 164-1225', N'Elderly person fallen in home', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Govert Flincklaan 5, 1181 XA Amstelveen, Netherlands', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', 4.86333, 52.30347, 0, 1, NULL UNION ALL
SELECT 3, 470, 31, N'201-4390', N'(85) XXX-XXXX', N'(85) 365-4641', N'Domestic disturbance', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Van Houweningenstraat 62-1, 1052 TP Amsterdam, Netherlands', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', 4.87062, 52.3734, 0, 1, NULL UNION ALL
SELECT 3, 471, 31, N'201-4390', N'(85) XXX-XXXX', N'(85) 88-3282', N'Public Disturbance', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Tugelaweg 89H, 1091 VN Amsterdam, Netherlands', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', 4.91731, 52.35509, 0, 1, NULL UNION ALL
SELECT 3, 473, 31, N'201-4390', N'(85) XXX-XXXX', N'(85) 403-7503', N'Cat stuck in tree', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'1171 Badhoevedorp, Netherlands', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', 4.7649, 52.32942, 0, 1, NULL UNION ALL
SELECT 3, 475, 31, N'201-4390', N'(85) XXX-XXXX', N'(85) 604-7683', N'Domestic disturbance', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Hoekenes, 1068 Amsterdam, Netherlands', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', 4.80137, 52.35466, 0, 1, NULL UNION ALL
SELECT 3, 476, 31, N'201-4450', N'(85) XXX-XXXX', N'(85) 46-3041', N'Vandalism', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Jan Evertsenstraat, 1061 Amsterdam, Netherlands', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', 4.83578, 52.37064, 0, 1, NULL UNION ALL
SELECT 3, 477, 31, N'201-4451', N'(85) XXX-XXXX', N'(85) 374-4198', N'Man fallen in water', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Hoogoorddreef 9B, 1101 BA Amsterdam, Netherlands', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', 4.94552, 52.30952, 0, 1, NULL UNION ALL
SELECT 3, 478, 31, N'201-4452', N'(85) XXX-XXXX', N'(85) 34-5456', N'Speeding', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Sloterweg 467, 1171 VE Badhoevedorp, Netherlands', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', 4.75709, 52.32399, 0, 1, NULL UNION ALL
SELECT 3, 479, 31, N'201-4453', N'(85) XXX-XXXX', N'(85) 503-6227', N'Car break in', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Hugo Floris Ruysstraat 8-1, 1063 KD Amsterdam, Netherlands', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', 4.82548, 52.38054, 0, 1, NULL UNION ALL
SELECT 3, 480, 31, N'201-4454', N'(85) XXX-XXXX', N'(85) 616-0689', N'Loud threatening behaviour', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Verbindingsdam 5, 1019 Amsterdam, Netherlands', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', 4.94032, 52.37505, 0, 1, NULL UNION ALL
SELECT 3, 481, 31, N'201-4455', N'(85) XXX-XXXX', N'(85) 310-2310', N'Public Disturbance', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Oranjehof 2, 1191 DA Ouderkerk aan de Amstel, Netherlands', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', 4.90733, 52.29586, 0, 1, NULL UNION ALL
SELECT 3, 482, 31, N'201-4456', N'(85) XXX-XXXX', N'(85) 293-4055', N'Public Disturbance', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Rentmeesterslaan 85, 1181 DR Amstelveen, Netherlands', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', 4.86127, 52.32087, 0, 1, NULL UNION ALL
SELECT 3, 483, 31, N'201-4457', N'(85) XXX-XXXX', N'(85) 602-2265', N'Public Disturbance', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Philip Popelweg, 1117 Luchthaven Schiphol, Netherlands', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', 4.79191, 52.29757, 0, 1, NULL UNION ALL
SELECT 3, 484, 31, N'201-4458', N'(85) XXX-XXXX', N'(85) 336-8247', N'Public Disturbance', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'1098 Amsterdam, Netherlands', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', 4.95682, 52.34707, 0, 1, NULL UNION ALL
SELECT 3, 485, 31, N'201-4459', N'(85) XXX-XXXX', N'(85) 674-5196', N'Public Disturbance', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'1098 Amsterdam, Netherlands', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', 4.94914, 52.3481, 0, 1, NULL UNION ALL
SELECT 3, 497, 32, N'201-4390', N'(871) XXX-XXXX', N'(871) 714-8371', N'Elderly person fallen in home', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'13 Hidson Road, Birmingham, B23 7', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', -1.86535, 52.5258, 0, 1, NULL UNION ALL
SELECT 3, 498, 32, N'201-4390', N'(871) XXX-XXXX', N'(871) 402-0290', N'Domestic disturbance', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'Drummond Road & Bordesley Green, Bordesley Green, B9 5', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', -1.84055, 52.48032, 0, 1, NULL UNION ALL
SELECT 3, 499, 32, N'201-4390', N'(871) XXX-XXXX', N'(871) 701-8181', N'Public Disturbance', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'31 Monsal Road, Great Barr, B42 2', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', -1.91102, 52.53702, 0, 1, NULL UNION ALL
SELECT 3, 501, 32, N'201-4390', N'(871) XXX-XXXX', N'(871) 459-9110', N'Cat stuck in tree', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'29 Parkdale Close, Erdington, B24 8', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', -1.84077, 52.51393, 0, 1, NULL UNION ALL
SELECT 3, 503, 32, N'201-4390', N'(871) XXX-XXXX', N'(871) 631-4768', N'Domestic disturbance', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'Nobel Way, Witton, B6 7', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', -1.885, 52.51526, 0, 1, NULL UNION ALL
SELECT 3, 504, 32, N'201-4450', N'(871) XXX-XXXX', N'(871) 143-6485', N'Vandalism', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'West Midlands, United Kingdom', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', -1.91433, 52.52402, 0, 1, NULL UNION ALL
SELECT 3, 505, 32, N'201-4451', N'(871) XXX-XXXX', N'(871) 530-1513', N'Man fallen in water', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'37 Oscott School Lane, Great Barr, B44 9', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', -1.89374, 52.54784, 0, 1, NULL UNION ALL
SELECT 3, 506, 32, N'201-4452', N'(871) XXX-XXXX', N'(871) 307-3073', N'Speeding', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'Hartshill Close, Buckland End, B34 6', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', -1.78917, 52.4984, 0, 1, NULL UNION ALL
SELECT 3, 507, 32, N'201-4453', N'(871) XXX-XXXX', N'(871) 659-2617', N'Car break in', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'72 Birkenshaw Road, Great Barr, B44 8', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', -1.89435, 52.54138, 0, 1, NULL UNION ALL
SELECT 3, 508, 32, N'201-4454', N'(871) XXX-XXXX', N'(871) 615-4215', N'Loud threatening behaviour', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'A4400, Birmingham, B4 6', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', -1.89329, 52.48578, 0, 1, NULL UNION ALL
SELECT 3, 509, 32, N'201-4455', N'(871) XXX-XXXX', N'(871) 682-6058', N'Public Disturbance', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'North Park Road, Stockland Green, B23 7', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', -1.87314, 52.52116, 0, 1, NULL UNION ALL
SELECT 3, 510, 32, N'201-4456', N'(871) XXX-XXXX', N'(871) 297-5962', N'Public Disturbance', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'Raddlebarn Road, Selly Park, B29 7', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', -1.9251, 52.44053, 0, 1, NULL UNION ALL
SELECT 3, 511, 32, N'201-4457', N'(871) XXX-XXXX', N'(871) 231-6944', N'Public Disturbance', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'2 Ethel Street, Smethwick, B67 5', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', -1.97072, 52.4778, 0, 1, NULL UNION ALL
SELECT 3, 512, 32, N'201-4458', N'(871) XXX-XXXX', N'(871) 833-8778', N'Public Disturbance', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'19 Low Wood Road, Erdington, B23 6', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', -1.85448, 52.52627, 0, 1, NULL UNION ALL
SELECT 3, 491, 32, N'201-4390', N'(871) XXX-XXXX', N'(871) 509-3839', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'120 Westminster Road, Birmingham, B20 3', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', -1.90771, 52.51329, 0, 1, NULL UNION ALL
SELECT 3, 492, 32, N'201-4390', N'(871) XXX-XXXX', N'(871) 91-9352', N'Car reported stolen', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'72 Blenheim Road, Moseley, B13 9', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', -1.88289, 52.43795, 0, 1, NULL UNION ALL
SELECT 3, 494, 32, N'201-4390', N'(871) XXX-XXXX', N'(871) 539-1010', N'Man fallen in water', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'38 Westbourne Road, Handsworth, B21 8', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', -1.94547, 52.50824, 0, 1, NULL UNION ALL
SELECT 3, 513, 32, N'201-4459', N'(871) XXX-XXXX', N'(871) 157-2977', N'Public Disturbance', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'Cuckoo Road, Nechells, B7 5', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', -1.85748, 52.50231, 0, 1, NULL UNION ALL
SELECT 3, 519, 33, N'201-4390', N'(78) XXX-XXX', N'(78) 370-386', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Høje Gladsaxe Vej, 2860 Søborg, Denmark', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', 12.50041, 55.72935, 0, 1, NULL UNION ALL
SELECT 3, 520, 33, N'201-4390', N'(78) XXX-XXX', N'(78) 840-247', N'Car reported stolen', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'1720 København V, Denmark', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', 12.54163, 55.66393, 0, 1, NULL UNION ALL
SELECT 3, 522, 33, N'201-4390', N'(78) XXX-XXX', N'(78) 504-670', N'Man fallen in water', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'2650, Capital, Denmark', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', 12.50143, 55.62213, 0, 1, NULL UNION ALL
SELECT 3, 525, 33, N'201-4390', N'(78) XXX-XXX', N'(78) 721-707', N'Elderly person fallen in home', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Kærmark 76, 2650 Hvidovre, Denmark', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', 12.45943, 55.6525, 0, 1, NULL UNION ALL
SELECT 3, 526, 33, N'201-4390', N'(78) XXX-XXX', N'(78) 158-590', N'Domestic disturbance', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'2605 Brøndbyvester, Denmark', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', 12.41451, 55.65109, 0, 1, NULL UNION ALL
SELECT 3, 527, 33, N'201-4390', N'(78) XXX-XXX', N'(78) 215-858', N'Public Disturbance', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Korsdalsvej, 2610 Rødovre, Denmark', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', 12.43305, 55.67434, 0, 1, NULL UNION ALL
SELECT 3, 529, 33, N'201-4390', N'(78) XXX-XXX', N'(78) 869-088', N'Cat stuck in tree', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Rådhusstien, 2610 Rødovre, Denmark', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', 12.45732, 55.68457, 0, 1, NULL UNION ALL
SELECT 3, 530, 33, N'201-4390', N'(555) XXX-XXXX', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'2650 Hvidovre, Denmark', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', 12.43304, 55.63449, 0, 4, NULL UNION ALL
SELECT 3, 531, 33, N'201-4390', N'(78) XXX-XXX', N'(78) 938-946', N'Domestic disturbance', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Ny Carlsberg Vej 23, 1760 København V, Denmark', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', 12.5437, 55.66583, 0, 1, NULL UNION ALL
SELECT 3, 532, 33, N'201-4450', N'(78) XXX-XXX', N'(78) 998-941', N'Vandalism', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Dalen 21, 2860 Søborg, Denmark', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', 12.5017, 55.72872, 0, 1, NULL UNION ALL
SELECT 3, 533, 33, N'201-4451', N'(78) XXX-XXX', N'(78) 579-651', N'Man fallen in water', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Korsdalsvej 97, 2610 Rødovre, Denmark', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', 12.43482, 55.67861, 0, 1, NULL UNION ALL
SELECT 3, 534, 33, N'201-4452', N'(78) XXX-XXX', N'(78) 199-624', N'Speeding', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'2650 Hvidovre, Denmark', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', 12.47843, 55.65073, 0, 1, NULL UNION ALL
SELECT 3, 535, 33, N'201-4453', N'(78) XXX-XXX', N'(78) 581-970', N'Car break in', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Drejøgade 37, 2100 København Ø, Denmark', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', 12.57094, 55.71243, 0, 1, NULL UNION ALL
SELECT 3, 536, 33, N'201-4454', N'(78) XXX-XXX', N'(78) 273-287', N'Loud threatening behaviour', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Dæmningsvej, 2300 København S, Denmark', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', 12.53351, 55.63102, 0, 1, NULL UNION ALL
SELECT 3, 537, 33, N'201-4455', N'(78) XXX-XXX', N'(78) 911-160', N'Public Disturbance', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Grøndalsvænge Allé 24, 2400 København NV, Denmark', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', 12.51978, 55.69462, 0, 1, NULL UNION ALL
SELECT 3, 538, 33, N'201-4456', N'(78) XXX-XXX', N'(78) 127-337', N'Public Disturbance', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Lindeager 10, 2605 Brøndbyøster, Denmark', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', 12.45369, 55.66208, 0, 1, NULL UNION ALL
SELECT 3, 539, 33, N'201-4457', N'(78) XXX-XXX', N'(78) 911-899', N'Public Disturbance', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Kirkesvinget, 2610 Rødovre, Denmark', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', 12.46565, 55.68267, 0, 1, NULL UNION ALL
SELECT 3, 540, 33, N'201-4458', N'(78) XXX-XXX', N'(78) 920-435', N'Public Disturbance', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Sydmarken 25A, 2860 Søborg, Denmark', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', 12.48211, 55.73301, 0, 1, NULL UNION ALL
SELECT 3, 541, 33, N'201-4459', N'(78) XXX-XXX', N'(78) 592-876', N'Public Disturbance', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Bjergvænget, 2400 København NV, Denmark', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', 12.53656, 55.71605, 0, 1, NULL UNION ALL
SELECT 3, 547, 34, N'201-4390', N'(2) XXXX-XXXX', N'(2) 375-5969', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Jung-gu Sindang-dong 290-131', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', 127.01577, 37.56039, 0, 1, NULL UNION ALL
SELECT 3, 548, 34, N'201-4390', N'(2) XXXX-XXXX', N'(2) 6130-1257', N'Car reported stolen', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Yongsan-gu Hannam-dong 11-379', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', 127.01178, 37.53298, 0, 1, NULL UNION ALL
SELECT 3, 550, 34, N'201-4390', N'(2) XXXX-XXXX', N'(2) 7220-3452', N'Man fallen in water', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Jung-gu Sindang-dong 852-10', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', 127.01707, 37.56004, 0, 1, NULL UNION ALL
SELECT 3, 553, 34, N'201-4390', N'(2) XXXX-XXXX', N'(2) 4066-0977', N'Elderly person fallen in home', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Yongsan-gu Garwol-dong 7-30', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', 126.97373, 37.54717, 0, 1, NULL UNION ALL
SELECT 3, 554, 34, N'201-4390', N'(2) XXXX-XXXX', N'(2) 7782-7562', N'Domestic disturbance', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Seodaemun-gu Bongwon-dong San1', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', 126.94652, 37.57535, 0, 1, NULL UNION ALL
SELECT 3, 555, 34, N'201-4390', N'(2) XXXX-XXXX', N'(2) 5017-7312', N'Public Disturbance', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Seodaemun-gu Hongje-dong 304-25', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', 126.94413, 37.58947, 0, 1, NULL UNION ALL
SELECT 3, 557, 34, N'201-4390', N'(2) XXXX-XXXX', N'(2) 292-9046', N'Cat stuck in tree', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Seongdong-gu Haengdang-dong 317-10', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', 127.02728, 37.55597, 0, 1, NULL UNION ALL
SELECT 3, 559, 34, N'201-4390', N'(2) XXXX-XXXX', N'(2) 8662-8829', N'Domestic disturbance', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Jongno-gu Hyoja-dong 139', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', 126.97316, 37.58305, 0, 1, NULL UNION ALL
SELECT 3, 560, 34, N'201-4450', N'(2) XXXX-XXXX', N'(2) 7749-4661', N'Vandalism', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Seongbuk-gu Seongbuk-dong 330-570', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', 126.99067, 37.59777, 0, 1, NULL UNION ALL
SELECT 3, 561, 34, N'201-4451', N'(2) XXXX-XXXX', N'(2) 1195-9680', N'Man fallen in water', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Dongjak-gu Noryangjin-dong 14-44', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', 126.94582, 37.5142, 0, 1, NULL UNION ALL
SELECT 3, 562, 34, N'201-4452', N'(2) XXXX-XXXX', N'(2) 9357-0577', N'Speeding', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Seodaemun-gu Hongje-dong 342-8', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', 126.93655, 37.58649, 0, 1, NULL UNION ALL
SELECT 3, 563, 34, N'201-4453', N'(2) XXXX-XXXX', N'(2) 3141-9337', N'Car break in', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Seongdong-gu Haengdang-dong 139-3', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', 127.03596, 37.55858, 0, 1, NULL UNION ALL
SELECT 3, 564, 34, N'201-4454', N'(2) XXXX-XXXX', N'(2) 8209-8184', N'Loud threatening behaviour', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Yongsan-gu Yongsan-dong 4-ga 19-2', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', 126.99017, 37.52777, 0, 1, NULL UNION ALL
SELECT 3, 565, 34, N'201-4455', N'(2) XXXX-XXXX', N'(2) 5718-1861', N'Public Disturbance', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Yongsan-gu Hannam-dong 60-27', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', 127.01122, 37.53852, 0, 1, NULL UNION ALL
SELECT 3, 566, 34, N'201-4456', N'(2) XXXX-XXXX', N'(2) 8525-2481', N'Public Disturbance', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Seodaemun-gu Hongeun-dong San19-19', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', 126.93099, 37.58348, 0, 1, NULL UNION ALL
SELECT 3, 567, 34, N'201-4457', N'(2) XXXX-XXXX', N'(2) 762-2527', N'Public Disturbance', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Yeongdeungpo-gu Yeouido-dong 87-3', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', 126.94869, 37.52738, 0, 1, NULL UNION ALL
SELECT 3, 568, 34, N'201-4458', N'(2) XXXX-XXXX', N'(2) 7167-6827', N'Public Disturbance', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Jongno-gu Pyeongchang-dong 147-5', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', 126.9721, 37.61006, 0, 1, NULL UNION ALL
SELECT 3, 569, 34, N'201-4459', N'(2) XXXX-XXXX', N'(2) 4122-4964', N'Public Disturbance', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Mapo-gu Sinsu-dong 429-9', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', 126.93733, 37.54452, 0, 1, NULL UNION ALL
SELECT 3, 575, 35, N'201-4390', N'(555) XXX-XXXX', N'(555) 776-2097', N'Woman involved in golf cart crash', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'24092 SE 12th Pl, Sammamish, WA 98075', N'David XXXXX', N'David So', N'Golf cart collision at golf course, one woman with moderate injuries', N'', -122.01724, 47.597893, 0, 1, NULL UNION ALL
SELECT 3, 576, 35, N'201-4390', N'(555) XXX-XXXX', N'(555) 682-6529', N'Car reported stolen', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'24067 NE 29th St, Sammamish, WA 98074', N'Jay XXXXX', N'Jay Henningsen', N'Car reported stolen from street outside house over night', N'', -122.01926, 47.636307, 0, 1, NULL UNION ALL
SELECT 3, 578, 35, N'201-4390', N'(555) XXX-XXXX', N'(555) 825-3849', N'Man fallen in water', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Beaver Lake, SE 18th Pl, Sammamish, WA 98075', N'Neil XXXXX', N'Neil Charney', N'A man has fallen in the lake, possible head injury', N'', -121.99096, 47.59348, 0, 1, NULL UNION ALL
SELECT 3, 581, 35, N'201-4390', N'(555) XXX-XXXX', N'(555) 715-4595', N'Elderly person fallen in home', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'497 241st Ln SE, Sammamish, WA 98074', N'Leonor XXXXX', N'Leonor Marques', N'An elderly person has fallen in their home', N'', -122.01769, 47.604218, 0, 1, NULL UNION ALL
SELECT 3, 582, 35, N'201-4390', N'(555) XXX-XXXX', N'(555) 120-9245', N'Domestic disturbance', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'22086 NE 15th St, Sammamish, WA 98074', N'Isabel XXXXX', N'Isabel Martins', N'Reports of a domestic disturbance reported by neighbor', N'', -122.044334, 47.62277, 0, 1, NULL UNION ALL
SELECT 3, 583, 35, N'201-4390', N'(555) XXX-XXXX', N'(555) 750-136', N'Public Disturbance', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Sahalee Way NE, Sammamish, WA 98074', N'Willem XXXXX', N'Willem Mevius', N'Reports of an altercation between two individuals at bus stop', N'', -122.047066, 47.63781, 0, 1, NULL UNION ALL
SELECT 3, 585, 35, N'201-4390', N'(555) XXX-XXXX', N'(555) 667-7589', N'Cat stuck in tree', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'22126 NE 11th Pl, Sammamish, WA 98074', N'Per XXXXX', N'Per Reitzel', N'There is a cat stuck in a tree, requires fire unit with ladder', N'', -122.045077, 47.619714, 0, 1, NULL UNION ALL
SELECT 3, 587, 35, N'201-4390', N'(555) XXX-XXXX', N'(555) 184-6348', N'Domestic disturbance', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'23026 NE 13th St, Sammamish, WA 98074', N'Louise XXXXX', N'Louise Toubro', N'Reports of a domestic disturbance reported by neighbor', N'', -122.030319, 47.620926, 0, 1, NULL UNION ALL
SELECT 3, 588, 35, N'201-4450', N'(555) XXX-XXXX', N'(555) 184-6332', N'Vandalism', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Pine Lake Park, 2401 228th Ave Se, Sammamish, WA  98075', N'Jón Harry XXXXX', N'Jón Harry Óskarsson', N'arson stolen vehicle smashed windows', N'', -122.034366, 47.584699, 0, 1, NULL UNION ALL
SELECT 3, 589, 35, N'201-4451', N'(555) XXX-XXXX', N'(555) 184-6132', N'Man fallen in water', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Pine Lake Park, 2401 228th Ave Se, Sammamish, WA  98075', N'Brian XXXXX', N'Brian Groth', N'drunk man in water water loud', N'', -122.038057, 47.588578, 0, 1, NULL UNION ALL
SELECT 3, 590, 35, N'201-4452', N'(555) XXX-XXXX', N'(555) 184-6519', N'Speeding', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Pine Lake Park, 2401 228th Ave Se, Sammamish, WA  98075', N'Michael XXXXX', N'Michael Zeman', N'intoxicatied individual breaking car driving fast smashed loud', N'', -122.039301, 47.586031, 0, 1, NULL UNION ALL
SELECT 3, 591, 35, N'201-4453', N'(555) XXX-XXXX', N'(555) 184-6339', N'Car break in', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Pine Lake Park, 2401 228th Ave Se, Sammamish, WA  98075', N'Rok XXXXX', N'Rok Palcic', N'Smashed window in car intoxication suspected', N'', -122.045352, 47.584352, 0, 1, NULL UNION ALL
SELECT 3, 592, 35, N'201-4454', N'(555) XXX-XXXX', N'(555) 184-6340', N'Loud threatening behaviour', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Pine Lake Park, 2401 228th Ave Se, Sammamish, WA  98075', N'Jerry XXXXX', N'Jerry Orman', N'Intoxication disturbance loud music', N'', -122.039559, 47.587854, 0, 1, NULL UNION ALL
SELECT 3, 593, 35, N'201-4455', N'(555) XXX-XXXX', N'(555) 184-6355', N'Public Disturbance', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Pine Lake Park, 2401 228th Ave Se, Sammamish, WA  98075', N'Ivo XXXXX', N'Ivo Haemels', N'dissonant crazy jazz music', N'', -122.037155, 47.588144, 0, 1, NULL UNION ALL
SELECT 3, 594, 35, N'201-4456', N'(555) XXX-XXXX', N'(555) 184-6331', N'Public Disturbance', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Pine Lake Park, 2401 228th Ave Se, Sammamish, WA  98075', N'Palma XXXXX', N'Palma Tude', N'smashed window vandalism breaking into car intoxication', N'', -122.038142, 47.584265, 0, 1, NULL UNION ALL
SELECT 3, 595, 35, N'201-4457', N'(555) XXX-XXXX', N'(555) 184-6312', N'Public Disturbance', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Pine Lake Park, 2401 228th Ave Se, Sammamish, WA  98075', N'Jerry XXXXX', N'Jerry Orman', N'drunk intoxication vandalism car', N'', -122.040503, 47.588115, 0, 1, NULL UNION ALL
SELECT 3, 596, 35, N'201-4458', N'(555) XXX-XXXX', N'(555) 184-6531', N'Public Disturbance', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Pine Lake Park, 2401 228th Ave Se, Sammamish, WA  98075', N'Aaron XXXXX', N'Aaron Painter', N'Dancing on cars drunk intoxication disturbance', N'', -122.039215, 47.583165, 0, 1, NULL UNION ALL
SELECT 3, 597, 35, N'201-4459', N'(555) XXX-XXXX', N'(555) 184-6323', N'Public Disturbance', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Pine Lake Park, 2401 228th Ave Se, Sammamish, WA  98075', N'Stuart XXXXX', N'Stuart Munson', N'Intoxication disturbance smashed blocking loud', N'', -122.037069, 47.588549, 0, 1, NULL 
GO
